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 |
54 |
#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
Solved! Go to Solution.
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
@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
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