Hi Alteryx Team, This is my Text Input file. I want to place 2 input results (i.e #1 and #2) into Row 1 Column 2 ([Null]) and Row 2 Column 3 ([Null]) NameNumberDetailsTotal No. Of Cars[Null][Null]No. Of Contracts[Null][Null]Average Value[Null][Null] #1 Input File - Row 1 Column 254 #2 Input File - Row 1 Column 3The Total No. Of cars are 54 The Output should be as such - NameNumberDetailsTotal No. Of Cars54The Total No. Of cars are 54No. Of Contracts[Null][Null]Average Value[Null][Null] Cheers

Output Issue

Hi Alteryx Team,

This is my Text Input file. I want to place 2 input results (i.e #1 and #2) into Row 1 Column 2 ([Null]) and Row 2 Column 3 ([Null])

Name	Number	Details
Total No. Of Cars	[Null]	[Null]
No. Of Contracts	[Null]	[Null]
Average Value	[Null]	[Null]

#1 Input File -

Row 1 Column 2

#2 Input File -

Row 1 Column 3

The Total No. Of cars are 54

The Output should be as such -

Name	Number	Details
Total No. Of Cars	54	The Total No. Of cars are 54
No. Of Contracts	[Null]	[Null]
Average Value	[Null]	[Null]

Cheers

Workflow

Help

Accepted answers

afv2688

Hello @henrygeorge,

Sorry for my previous post. As you mentioned I totally forgot to add the other values.

Is this what you were looking for?

Regards

join_by_position.yxmd

All comments

afv2688

Hello @henrygeorge ,

Could you give us more details? Do the other tables have any key value to do the join?

Are the records from input 1 and 2 in the same order?

Without any more information I could only suppose that this is what you are looking for.

Regards

join_by_position.yxmd

henrygeorge

@afv2688 Hi in your Join Output Anchor at the end, I don't see the other names Like No. Of Contracts, Average Value. But you are right in terms of Input (there are 3 inputs). This is your Text Input 1

Name	Number	Details
Total No. Of Cars
No. Of Contracts
Average Value

There are no Unique Values. Records are in the Same position as your Input File 2 and 3. I actually have a Bunch of such Inputs that I have to place in Input File 1

I want the Output to be -

Name	Number	Details
Total No. Of Cars	54	The Total No. Of Cars are 54
No. Of Contracts
Average Value

From other Input Files I will Fill similarly Column 2 Row 2 and Column 3 Row 2, and the est.

Please do help me as I'm stuck

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703