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 · Accepted solution]

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

[prpanw]

Thank you so much. Transpose option worked for me

[prpanw]

Could you please help me with another senerio please?

I have a policy that contains three line items. I need to identify the two line items where their combined sum equals zero.

Has anyone worked on a similar requirement before? Any guidance or examples would be greatly appreciated.

Policy	Insured	NetUSD
A123	abc	-13
A123	abc	12
A123	abc	37

[jrlindem]

@prpanw  Happy to help, but since this is a new ask, it should go in its own post (if you haven't done that already).  Please move to a new discussion and I or others would be happy to help!  -Jay