topic Re: Data Reconciliation in Alteryx Designer Desktop Discussions

Data Reconciliation

prpanw — Mon, 27 Oct 2025 12:32:41 GMT

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.

Re: Data Reconciliation

jrlindem — Mon, 27 Oct 2025 13:10:14 GMT

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

Re: Data Reconciliation

dreldrel — Mon, 27 Oct 2025 18:36:10 GMT

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

Re: Data Reconciliation

prpanw — Tue, 28 Oct 2025 14:56:22 GMT

@jrlindem love to hear from you.

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

Re: Data Reconciliation

jrlindem — Tue, 28 Oct 2025 15:03:04 GMT

@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

Re: Data Reconciliation

prpanw — Thu, 13 Nov 2025 10:56:14 GMT

Thank you so much. Transpose option worked for me

Re: Data Reconciliation

prpanw — Thu, 13 Nov 2025 13:03:04 GMT

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

Re: Data Reconciliation

jrlindem — Thu, 13 Nov 2025 14:50:16 GMT

@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