Martin Hamilton
- Total activity 51
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 14
Activity overview
Latest activity by Martin Hamilton-
Martin Hamilton commented,
ignore this. am not thinking and sorted it now...cheers
-
Martin Hamilton created a post,
PIVOT Table - Convert Rows to Columns
Hi I always struggle and dont think I have ever found an easy way to do this in the years I have been using D360/LAE. Here is my data: serviceID,plan_instance_field,plan_instance_valueMYRA04/WAVE/...
-
Martin Hamilton commented,
This is brilliant. Many thanks for your help and patience. cheers Martin
-
Martin Hamilton created a post,
convert a date which has no zero on the month
Hi I have date being passed which has no leading zero (although a zero is present when appropriate). e.g. 7/15/2021 so in a format m/dd/yyyy How do i convert this into a format of yyyyMMdd ? So it ...
-
Martin Hamilton commented,
Works lovely thanks Gerry. You mentioned the ability to amend this to pick up null or empty fields. I tried to amend the script but i failed miserably. I want to pass through all fields into the ne...
-
Martin Hamilton commented,
yes in brainscript as I am not familiar with python enough to use the transform nodes. I am getting an error with this once placed into a transform node: Field "data" does not exist on output (0) "...
-
Martin Hamilton created a post,
Combine columns into a single output column with a delimiter
Hi i am trying to output multiple columns into a single column and delimit using a pipe. There is a way but seems clunky: emit 'column1'+"|"+'column2'+"|"+'column3' as Data It works but if i add a ...
-
Martin Hamilton commented,
Many Thanks Adrian this worked a treat! hope you are well! I did have multiple prefixes to output so used a superceded transform node to split into multiple output pins Martin
-
Martin Hamilton created a post,
read a delimited file with a mix of columns populated
Hi I have a file that contains multiple records which are of a differing recordtype. This means that certain record types have more columns than another. The delimiter is a pipe. I tried to use th...
-
Martin Hamilton commented,
Hi is anyone able to provide guidence on this question? Thanks Martin