Hi Experts,
Need some quick help in below dataset
Need data in below format.Below image is that of excel but need alteryx o/p in similar fashion
Thanks in advance:)
Hi @Polite123
Is there any label for this row
Nope:
I'm not sure what you're trying to do. You can simply cut and paste into a text input tool?
You might add Record ID tool (Preparation tools) to number each row, then use the row number in subsequent formulas (eg. IF rowID=1...). Then once you've done everything you need to, use the select tool to de-select the record ID.
You might consider populating the blanks with a temporary filling string to replace at the end of the process too - whereas you might want the output to be blank, it might help to have a temporary containing value in there during your process and to reference in your formulas during the calculation part. You can always add a formula tool at the end to make those cells blank etc at the end of your workflow before output.
@Polite123
You got to give your input and desired output if you want some help here.🙄