Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi guys!
So I have 1 text file, which I want to input as a single line text itself. I have imported it as a CSV. But this has caused the data to break down into multiple rows, as you can see in the image.
My aim is to have just 1 row, which has the entire data
<!-- $Id$ --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html>
Something of this sort.
I have tried using crosstab function to change all the row data to column. But this results in all row data to be the column header, which cannot be merged again! Looks like this:
Can you help me to either copy the column name into the data too, so I can merge it?
Or could you propose some other method to do it?
Solved! Go to Solution.
Hi @yashs,
You can configure the summarize tool to concatenate all your data without a delimiter (or with a space or line break if you prefer), and that should do the job.
Here's an example:
Hi @yashs
Here is a workflow for the task.
Output:
Workflow:
The highlighted box part is where you mention separator.
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
