Using templates for file names, plugboards, composite columns, searches, tooltips

[LibBikher]

thank you for your help

I have the file name and asin. I have no clue how to do result. but i do have one other problem. The file names all have _ebok on the end. This will result in all of the compares resulting in no. Any idea for a work around?

[LibBikher]

I have been fighting with this all afternoon. I figured out the file name issue but i cant make the custom column work.

Lookup Name: results
Column Heading: Results
Column Type: Column built from other columns
Template: {results: strcmp(#asin, #file, yes, no, na)}

But it doesn't work. What am I doing wrong?
Please help

[davidfor]

Originally Posted by LibBikher

I have been fighting with this all afternoon. I figured out the file name issue but i cant make the custom column work.

Lookup Name: results
Column Heading: Results
Column Type: Column built from other columns
Template: {results: strcmp(#asin, #file, yes, no, na)}

But it doesn't work. What am I doing wrong?

The template can't reference the column it is for. Try:

{#asin:strcmp(#file, yes, no, na)}

[LibBikher]

Thank you for your help. The equation works but isn't returning accurate results. Even though the asin and file name match its returning na NA should only come up if one or both fields are empty.

I've attached snapshots Im not sure why this is so difficult

[BetterRed]

Originally Posted by LibBikher

Thank you for your help. The equation works but isn't returning accurate results. Even though the asin and file name match its returning na NA should only come up if one or both fields are empty.

I've attached snapshots Im not sure why this is so difficult

Try changing 'file' to:



BR

[davidfor]

Originally Posted by LibBikher

Thank you for your help. The equation works but isn't returning accurate results. Even though the asin and file name match its returning na NA should only come up if one or both fields are empty.

I've attached snapshots Im not sure why this is so difficult

That could be a formatting issue as @BetterRed suggested. But, I think I would do the template as:

program:
strcmp(raw_field('#asin'), raw_field('#file'), 'yes', 'no', 'na');

That should prevent issues with how the data is formatted for display.

[LibBikher]

BetterRed I was still getting na even though they matched

davidfor I tried your suggestion:
template: {#asin:strcmp(raw_field('#asin'), raw_field('#file'), 'yes', 'no', 'na')}
error: TEMPLATE ERROR: incorrect number of arguments for strcmp

[chaley]

Originally Posted by LibBikher

BetterRed I was still getting na even though they matched

davidfor I tried your suggestion:
template: {#asin:strcmp(raw_field('#asin'), raw_field('#file'), 'yes', 'no', 'na')}
error: TEMPLATE ERROR: incorrect number of arguments for strcmp

You didn't actually try what he suggested. Try the 2 lines of code *exactly* as he wrote it, including the word "program". Note that there are not any curly braces in his suggestion.

[LibBikher]

i didn't know I could put the word program in there. OK done. Now it is returning NO even though they match. Is it possible that this is because I am using the GetFileName plugin to get the file name and extract the extension? So that even though I cant see the file extension in the File column, the system still does?

[chaley]

Originally Posted by LibBikher

i didn't know I could put the word program in there. OK done. Now it is returning NO even though they match. Is it possible that this is because I am using the GetFileName plugin to get the file name and extract the extension? So that even though I cant see the file extension in the File column, the system still does?

davidfor's template says that "no" is the correct answer if the values match. To be precise, the template says

• return "yes" if #asin is lexicographically less than #file'
• return "no" if #asin equals #file'
• return "na" if #asin is lexicographically greater than #file'

I confess that I can't figure out what you really want to happen so I can't suggest changes.

[LibBikher]

ok so it is working. What i am looking for is:

return "yes" if #asin = #file
return "no" if #asin ≠ #file
return "na" if #asin or #file is empty

[chaley]

Originally Posted by LibBikher

ok so it is working. What i am looking for is:

return "yes" if #asin = #file
return "no" if #asin ≠ #file
return "na" if #asin or #file is empty

Try this

program:
	asin = raw_field('#enum2');
	file = raw_field('#enum2');
	first_non_empty (
		strcmp(file, 'None',  '', 'na', ''),
		strcmp(asin, 'None',  '', 'na', ''),
		strcmp(file, asin, 'no', 'yes', 'no')
	)

Note that it won't work if file or asin can ever be the word "None".

[LibBikher]

Chaley I copied and pasted that directly into the template field for the results column and everything came back NA

[chaley]

Originally Posted by LibBikher

Chaley I copied and pasted that directly into the template field for the results column and everything came back NA

Did you change the lookup keys in the first two lines to those in your database? E.g.

asin = raw_field('#asin');
file = raw_field('#file');

[LibBikher]

IT WORKS!!!! Thank you everyone for your help.