Hi Community,
I would like to ask about the append fields tools as i not familiar with it.
Currently , i have one set of data A as shown in the below and i would like to add in one column for the Company Code ( manually added in the alteryx) as per the screenshot below.
May i know how i build the workflow for this? Should i use Append field
Solved! Go to Solution.
Should all values be the same for each record? If so, you can simply use a formula tool with the value hardcoded in it.
Hi @ echuong1,
Yes It is the same. May i know how can I select the Company Code as first column as shown in the screenshot below?
In addition, could you please advise how should i remove the first row of the data after importing into Alteryx?
You can use a Select to change the column order.
It looks like your headers are not on the first line as well - in the Input, change the start line.
Hi @SH_94 ,
For the first question, you can use a select tool to move the fields into position. You can highlight a field or fields and use the right click and drag method, or you can use the arrows at the top:
For the second, you can use a sample tool to skip the first N records, where N=1.
Alternatively, you can use a filter tool to select where F1 is not null.
M.
Hi @ echuong1,
Thanks for the information.
However, for point number 2 , i dont have the layout as per your screenshot . Kindly find the screenshot below which happening in my alteryx.
Your file is a binary excel file, which has different configurations. For this, you can use a Sample to skip the first N lines. From there, you can use a dynamic rename to move your headers up.
