Column Name supplied as Input but getting recognized as text
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :(
- Labels:
- Batch Macro
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @gangwar59 - Here is a possible solution. Not sure if I fully understood your requirement though.