Hi,
I have dataset which contains columns “cust id” and “pan id”
these columns does not have any data it’s totally blank. I want the output with some row numbers with null.
Input data:-file A
cust id. pan id
123ghi. 1234
123ijk. 1234
123opi. 5654
123uti. 5654
………………..
Input data :- file B
cust id. pan id
—————————-
when I union this data I want 8 rows in final output. Like this.
final output to be like this
record cust id. pan id
1 123ghi. 1234
2 123ijk. 1234
3 123opi. 5654
4 123uti. 5654
5 null. null
6 null. null
7 null. null
8 null. null
thanks in advance
Perhaps use a generate rows toll tool on input b and make 4 rows then union together and use a select tool to deselect the created row count field.
I have attached a workflow unioning generate rows onto the empty input then select tool to deselct generated rows and union the two inputs for desired output
@gurmukh Change formula tool to generate the number of null rows:
@ed_hayter, Thank you so much for the solution
@BS_THE_ANALYST,
Thanks for the solution