Hi All,
I am stuck on the below part of my canvas and it would be great if anyone has any method to generate the below mentioned output.
The below is just an example of the data that I am stuck on and you can consider it as an input as well.
Tax_0 | Data_0 | FullPath |
Tax=0 | C:\Users\Downloads\Tax + ".txt" | |
A112,A114 | C:\Users\Downloads\Tax + ".txt" | |
Data=0 | C:\Users\Downloads\Data + ".txt" | |
A113,A115 | C:\Users\Downloads\Data + ".txt" |
Basically the desired output should generate in a text format without the quotes and also in different folders that i have mentioned above. Just an example of the desired output.
In folder C:\Users\Downloads\Tax the required output is .txt is
Tax=0
A112,A114
In folder C:\Users\Downloads\Data the required output is .txt is
Data=0
A113,A115
Currently in the canvas output when i use .csv and try to generate this output I'm stuck on the following pointers .
1. If the first line is a delimiter there will be quotes. But i need to make sure that my first line is a delimiter without the quotes in. (I have tried parse and formula tool as well but I'm not sure if its working for me.)
2. Also for Data folder output i am getting a ( , ) before the data.
Thanks,
Ash.
Solved! Go to Solution.
Hi @Ash_dsz ,
I'm not sure to understand what you want ! Are you looking to get the files Tax.txt and Data.txt to contain both two rows ?
Hi @Jean-Balteryx,
Im looking to have the file tax.txt to contain only the tax column and the file data.txt to contain the data column.
Can both information (tax and data) be in the same column ?
@Jean-Balteryx
Basically my input is something like the below table
Tax_0 | Data_0 | FullPath |
Tax=0 | C:\Users\Downloads\Tax + ".txt" | |
A112,A114 | C:\Users\Downloads\Tax + ".txt" | |
Data=0 | C:\Users\Downloads\Data + ".txt" | |
A113,A115 | C:\Users\Downloads\Data + ".txt" |
And my output should be .txt and should look like the below.
In folder C:\Users\Downloads\Tax the required output is .txt is
Tax=0
A112,A114
In folder C:\Users\Downloads\Data the required output is .txt is
Data=0
A113,A115
No. So basically i want the tax column to be in the tax output path and the data column to be in the data output path.
Right now in my canvas im getting quotes ('') in the data output which i do not want. If i click the "Quote output field" as "never" it gives me an error stating delimiter should not be the first line, but unfortunately my data requires the delimiter (=) to be in the first line.
Hi @Ash_dsz
It would possibly not work. Because value is A112,A114 where comma is a possible delimiter. There is no way for the system to get to know that comma is not a delimiter if quotes are not used.
If comma is not there in the column data your workflow will work.
Is there a way to remove the comma that the output tool generates before the quotes in the data folder?
I think @atcodedog05 's solution works best for your use case ! If you have a new file/column, you'll need to add a new filter/select/output combination.