MikeP
New Contributor II
Joined 4 years ago
User Profile
User Widgets
Contributions
Excel Parser not producing empty document view
Hello Community, I have a problem where my excel parser snap is not producing an output document view when I’m parsing a file with only headers present and no actual data (this is a valid business scenario we have to deal with). I have the same pipeline logic when dealing with CSV parser (with empty data and only headers file), and I at least get an empty document view to check against (using an expression like $.isEmpty()). Is this a bug in the Excel Parser snap? In the views tab on the excel parser I have output min of 1, so I should get a document output to check against (like the csv parser does), empty or not. There is nothing of any help in the documentation for this Excel Parser snap I can see to help me, so any help or workarounds to this would be appreciated. Thanks Mike3KViews0likes2CommentsHow can we "prettify" a Json data section presented in an email with the HTML table template type chosen?
Hello community, is there anyway we can manipulate a part of a document for a json section to make it more reader friendly ie prettify it, especially in the html table format option in the Email sender snap. So it doesn’t look bunched in the email body, in a table column and much more reader friendly. This is a small example of the problem:- So its maybe looks like this in the email body when its rendered :- { “Results”:{ “Title”:" Results 2", “FileInfo”:{ “Files”:[ { “Name”:“OLD”, “Type”:“Directory” } ] } }, “Files”:[ { “Name”:“OLD”, “Type”:“Directory” } ] } Ok so the editor had screwed the tabbing structure up here, but you get the idea! Any help appreciated. Many thanks, Mike2.2KViews0likes1CommentRe: File Operation - Move gives error after file is moved
@j.angelevski Yep I already have a file reader previously working successfully in a upstream pipeline- it reads ok everytime. I am trying to move upto 2 .csv files. Its a simple archive business objective after the files have been processed. The error seems to be consistent when I have 2 files and one of the files has no data (a valid business scenario). It always errors on the no data file (a file with just headers present in the csv). BUT if I run the pipelines so targeting only that empty data file (so only processing 1 file) then I get no error at all and the same file is successfully moved to the correct archive folder. If I run for the 2 files scenario BOTH WITH DATA in them, then no errors and both files get archived into there respective target folders. But the file operation snap error stack trace is like above in the original post, when it happens. Am totally baffled now.2.9KViews0likes2CommentsRe: How do we check if NO DATA in a CSV file after filtering out headers
hi j.evegelvski, sorry for delayed reply. I think I sussed it now. !$.isEmpty() although no errors syntactically on setting it in the expression validation, it doesn’t seem to functionally work. However, $.isEmpty() == false, the more explicit syntax, does work, therefore the router flow now conforms as expected. Thanks for your assistance!4.5KViews0likes2CommentsRe: How do we check if NO DATA in a CSV file after filtering out headers
hi j.evegelvski, the files will always have header text values like “Emp_ID”, the rows after this will be empty. I cant identify if we have any data for this file situation - no data. My dev head is saying maybe a ‘row count’ property (if data in any rows) after header row filtered out, this would be handy, but doesn’t seem to exist. Then just check if this value > 0. Addendum: After the CSV Parser snap, then the next snap is a straight mapper snap for the document ($) the output view is Hence why I thought the expressions I mentioned initially would work.4.5KViews0likes4CommentsHow do we check if NO DATA in a CSV file after filtering out headers
Hello, I need to check if there is no actual data after reading and parsing a CSV file, I am using the CSV Parser and have checked the ‘Contains Header’ (as we will always have a row with headers), I then follow it with a Mapper. If we have no data at this point we need to stop processing and go down a different route. I’m struggling with how after the Mapper, I check if no data is present in my document ($). We have a router snap next and have tried the following options, but none seem to work in the expression window:- $ == null $.isEmpty() Any help appreciated. Thanks Mike6.6KViews0likes6Comments