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

Stack an empty input with ensure fields.yxmd

Screenshot 2023-06-23 150812.png