Macro or Multi-Field Formula?
- 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 trying to figure out how to dynamically join two types of columns with the same column number. See below for clarification. I need this to be dynamic as the amount of column numbers change so manually joining them is not an option.
End goal is SMARcolumnId1 + columnId1, SMARcolumnId2 + columnId2, and so on...
I am pretty sure it is a simple solution, but I have been staring at this problem all week with no luck.
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
2 things pop into my head when looking at this problem and how you're describing it. #1, I think about a dynamic select to bring in [name] = number 3 different times.
The second, is it might be possible with a transpose to digest the name of the column a little more thoroughly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I ended up resolving this after talking to someone else.
Since the "SMARColumnID" was constant for each row and can be correlated to each of the "ColumnID" column numbers, I ended up using a separate table with that info and the dynamic replace tool as a concatenation tool.