Issue joining data to union

[wonka1234]

Hi all,

I am trying to join back my original dataset to the filters and unions I do. (first red box on left)

However I want to keep my same number of records of my unions

The reason I select column by column, filter out the not nulls then union, is because I append all the non null values in each column to one new formula field.(ID final)

The issue is i need the corresponding columns from my first select.. so the columns that belong to those non null for each column.

it is abit complicated but any help would be appreciated.

[wonka1234]

@clmc9601   not unique identifier. 

Take values from col A put into Id final. Below those, take values from Col B  put into id final. etc.

But i must take the row associated with the values  inputted into id final.

[wonka1234]

@clmc9601    how does the transpose work? would you mind doing a workflow using my data?

[clmc9601]

@wonka1234, do any of these Browse tools represent your desired result?

Please forgive my slowness to understand...

[clmc9601]

Just saw your second message about Transpose. I already included it in the workflow above, so I'll add an explanation: transpose turns columns of data into rows. Rather than having a column for each of your ID fields, transpose will add a row for each.

[wonka1234]

@clmc9601 

Your first browse actually looks like the desired result! however is it possible to include the corresponding user Id fields in this?

[clmc9601]

@wonka1234  do you mean the user ID fields that are in the [Name] column? They are split into rows instead of columns. Do you mean you want them all in the same row?

If there are other fields you want to pass through the Transpose to show up like [Is_Manager] and [c_Country], select them as "Key Columns" in the Transpose tool.

[wonka1234]

@clmc9601  Yes, i want the userId in the name column as actual columns , along with c_country, etc. I want all original columns to remain in the output with the addition of the id_final column.

[clmc9601 · Accepted solution]

@wonka1234like any of these?

[wonka1234]

@clmc9601  thanks! sigh, i think this is fine... not sure why mainframe isnt 202 lol, but im getting confused at this point.

[clmc9601 · Accepted solution]

@wonka1234  it's because you're cross-multiplying your data. How many employees are you expecting to end up with? My initial assumption was you'd want to keep the same number of employees (3522) rather than duplicating some rows (resulting in ~6k).

You're welcome! Happy to keep troubleshooting with you if you'd like. If you're satisfied with the result, could you please mark one of the above posts as a solution? That helps other community members find the result and shows the post resolved. Thanks!