Filter the data based on one Record ID after another till there are no RecordIDs

[Manjari_T]

Hi All, 

I have a macro (1st Macro) that picks txt files on one by one and extracts a value from the file until there are no more files, this is working currently

however, inside the 1st macro I need another macro (2nd Macro) that will filter the Record ID one by one until there are no more recordIDs. I tried various macros from different posts however not getting to work for my dataset. Requesting help.

I have provided sample data of the dataset for the 2nd macro

RecordID	Column1	Column2
1	Choco	A
1	Icecream	B
1	Cake	C
2	Choco	D
2	Icecream	E
2	Cake	F
3	Choco	P
3	Icecream	Q
3	Cake	R
4	Choco	L
4	Icecream	M
4	Cake	N

[KGT]

I'm not sure what you are after. In order to filter the dataset, you could just use a filter, and if everything in that iteration of the macro has to go through the filter, then don;t filter at all, and rather just do the operation against the table with a Join. What output are you expecting?

[Manjari_T]

Hi @KGT, 

Thank you for you response. I need the output to look like this:

for the 1st Iteration when RecordID = 1 then I would like the macro to filter for RecordID 1 rows

RecordID	Column1	Column2
1	Choco	A
1	Icecream	B
1	Cake	C

For 2nd iteration the RecordID = 2 then the output is 

RecordID	Column1	Column2
2	Choco	D
2	Icecream	E
2	Cake	F

Similarly for all RecordIDs. Please see the attached macro which I am working on I am not sure where I am going wrong 

[caltang · Accepted solution]

My attachment doesn't solve your need but it does fix your macro...

Actually I don't know what you're trying to do. 

[KGT]

@caltang has fixed your macro, the control parameter was connected to the wrong side of the macro. It needs to connect to the upside down question mark.

Your filter within the filtering macro is only working because you are replacing the number including the quotes. Not sure why you are converting to string first if your control parameter is numeric.

In general Macros within Macros are fine, however you need to remember that it creates an extra dependency, hence I only do it if it's necessary. That's the reason I was asking about the output, and what you are trying to achieve.

Not many people these days know about the "supporting_macros" and "supporting_templates" directory structure and so dependencies are up to the user. Of note, if you use those directories, the contents will not show up in the parent Macro Repository.

[Gaurav_Dhama_]

Regarding the packaging the subMacros, refer the comment section of this blog post.

PDF Packaging in Alteryx Designer - Alteryx Community

[Manjari_T]

Thank you @Caltang this really helped.