This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
darshthakkar
Valued Contributor
since ‎03-10-2022
Monday

User Statistics

  • 382 Posts
  • 17 Solutions
  • 553 Kudos given
  • 94 Kudos received

User Activity

Converting value of input schema to distinct columns

06-20-2023
Hi Team, I’m reading a text file and wanted to fetch DISTINCT columns out of the data itself, screenshot below for your reference. .txt file: When I read the above data in snaplogic, the format is: Tried with $.merge(), GroupByN, CSV parse (contain...

Can we round integers to 2 digits?

06-20-2023
Hi Team, I was using the Math.round() but was wondering if we can decide on the decimal digits for the rounding. For example, number = 3.14125252 Desired output = 3.14 With Math.round(), output is 3. Any suggestions on how to use the native Round(num...

Routing files from S3

06-15-2023
Continuing the discussion from How to load Today Date Files from s3 Bucket to SLDB:

Reading data from tsv file

06-14-2023
Hi Team, How can we read data from tsv file? I have tried using CSV and Fixed Width Parser but no luck thus far. Thanking in advance for your help. Regards, Darsh

Consolidate Header file and Data file

06-12-2023
Hi Team, I’m having 2 separate excel files; one containing the headers ONLY and the other one having the actual data. How can I MERGE these 2 files into a single entity so that further transformations can be applied and eventually sent to downstream ...
View more