This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.