Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Modification Needed

r4upadhye
11 - Bolide

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:

test0.png

 

Expected Output:

expected.png

 

 

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

test1.png

 

thanks in advance.

rahul

7 REPLIES 7
MarqueeCrew
20 - Arcturus
20 - Arcturus
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
🏝
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
gnans19
11 - Bolide

Hi @r4upadhye, @MarqueeCrew

 

Another approach using string concat. Attached workflow.

 

test.png

r4upadhye
11 - Bolide

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
11 - Bolide

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
11 - Bolide

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

is it not possible?

 

gnans19
11 - Bolide

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

r4upadhye
11 - Bolide

thanks for the solution,

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

Labels