One Target column Referencing another

Question: If I have a target column that needs to reference another target column, can I simply reference the column name? Or do I have to copy all of the rules that make up the referenced column?

For example, can I do something like the following for Column2:
Column 1 = when(Record/whatever = 0) value=[100] otherwise value=[200]
Column2 = Column1 + “10000”

Or do I have to do:
Column 1 = when(Record/whatever = 0) value=[100] otherwise value=[200]
Column2 = when(Record/whatever = 0) value=[10010000] otherwise value=[20010000]

-------
Solution:
Please follow the below steps:

1. Create a variable at record level var1 = when(Record/whatever = 0) value=[100] otherwise value=[200].
2. Map this variable var1 to that Column1(You can map this var1 by using double click from left side window under the local variable).
3. Use this same var1 in Column2 by using concat function. concat( var1, '10000')

Have more questions? Submit a request

0 Comments

Article is closed for comments.