Essentially I have 2 rows, each from a diff node/source
that need to be 1 row.. I tried a CAT and it didnt work.
_________________col 1 ___ col 2 ____ col 3 _____ col4 ____col 5
row1 from a filter:___Null____Null______Null______Null_____ Hello
row2 from b filter:___AAA___BBB______CCC_____DDD_____Null
output needs to be AAA,BBB,CCC,DDD,Hello
Please sign in to leave a comment.