Hi all,
I am stuck with one flow so will be very helpful if any solution is suggested.
Scenario -
1. Input File:-
I am supplying the column Name as input ex. in below Header is the name of column and Name1 is the text value..
Header |
Name1 |
2. Dynamic Input tool-
Connecting to my Database i am fetching 2 columns
Name1 | Name2 |
0 | TestInput |
When i use Apend Tool, I get the value as below
Name1 | Name2 | Header |
0 | TestInput | Name1 |
My issue is, I want the actual value '0' instead of Name1 under Header as that is the value of Name1.
Since this is macro i am trying to create therefore simply adding formula tool to make Name1 value equal to DynamicInputTool output value will not help here as this need to extended for different tables and columns will vary.
Is there any way i can make altreyx understand that Name1 under Header is actually name of the another column and not text field ?
FYI.. Adding brackets [ ] is again not working here :(
Hi @gangwar59 - Here is a possible solution. Not sure if I fully understood your requirement though.