Manual Input data information in alteryx

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

Common Use Cases

Accepted answers

echuong1

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.

New Workflow2.yxzp

All comments

pedrodrfaria

Hi @SH_94

If you want to manually add data to a workflow, you can add the Text Input tool with the data to be added and use a join to blend the data in the workflow with the manually added data.

Pedro.

echuong1

Should all values be the same for each record? If so, you can simply use a formula tool with the value hardcoded in it.

New Workflow2.yxmd

SH_94

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?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335