Data Reconciliation

[prpanw]

HI Folks,

I am workin on a reprot where a column (note) which has audit no and they could be multiple in single cell and length could be 7, 8 ,9 digit. basis on thoe audit no I have to get the data from MOira file. I am able to extract audit no through using Regix tool in different colums but Now I have to get relevent data from Moira file basis on audit no because there are different row for each audit no in Moira file. 

[jrlindem]

If I'm understanding correct, you've...

• Used regex to split the Audit Numbers into new columns
• And how you need to connect that to a "MOira" file?

If so, then I would use TRANSPOSE to convert those columns to rows, and then you can connect to your second data source using the JOIN tool, provided there is a Audit Number match in that file to relate the data.

If this is not what you are asking for support on, could you explain in more detail?

Thanks, -Jay

[dreldrel]

Just to clarify - have you ingested your Moira files into Alteryx?

[prpanw]

@jrlindem  love to hear from you.

Can we connect to discuss further please becaseu  I can see hope to get r

[jrlindem]

@prpanw Hey there!  Happy to help.  Are you able to attach a sample of your data (deidentified) so that I can build out an illustrative workflow to help?  -Jay