Data Reconciliation

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.

Data Investigation

Accepted answers

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

All comments

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 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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317