Data Modification Needed

[r4upadhye]

Hi,

Im having some challenge in modifying my data. Half-baked workflow is attached too, pls can you walk me through the last steps?

Input:

Expected Output:

so far i see wrong numbers in the last tool, which is why i cannot understand why it can't do a simple look-up

thanks in advance.

rahul

[MarqueeCrew]

RecordID
Transpose, group by recordid and date
Filter (get rid of empty or null values)
Multi-row formula with formula looks at row-1 and if recordid is not equal to recordid, then name is yesterday otherwise it is today.
Cross-tab, group by recordid and date with header is name and value is value

I hope that this is enough to get you to the solution.

Cheers,

Mark
🏝

[gnans19 · Accepted solution]

Hi @r4upadhye, @MarqueeCrew

Another approach using string concat. Attached workflow.

[r4upadhye]

How could you concat in a summary tool?

im using version 10.6 is it available in a higher version & not in 10.6?

[gnans19]

Open my alteryx workflow in notepad and change the version to 10.6 and save. You can open the workflow in Alteryx 10.6.

[r4upadhye]

no, actually i want to use this concat in summary tool in version 10.6

is it not possible?

[gnans19]

Also you can concatenate values as long as they are converted to string. You'll see concatenate under string aggregation of summarize tool.

[r4upadhye]

thanks for the solution,

ya i got this, it was only possible for string data type