How to take blank as Null

[gurmukh]

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 

[ed_hayter]

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

[BS_THE_ANALYST]

@gurmukh Change formula tool to generate the number of null rows:

[gurmukh]

@ed_hayter, Thank you so much for the solution

[gurmukh]

@BS_THE_ANALYST,

Thanks for the solution