topic Re: How to transform a field into a new field using the old field as part of a string in the new field in Getting Data In

How to transform a field into a new field using the old field as part of a string in the new field

user93 — Thu, 16 Jan 2020 18:22:22 GMT

I have a list of IDs in a report using a lookup. I want to deliver the report using the IDs to create a URL.

id=abcd1234

Transform field and write new filed to the lookup table

url=https://www.domain.com/go/

|inputlookup basetable
|search value=WhatIsBeingReported
|table id,title,url

Re: How to transform a field into a new field using the old field as part of a string in the new field

acfecondo75 — Thu, 16 Jan 2020 19:45:46 GMT

Hi again @user93!

you can concatenate field values and strings together using an eval statement. Then you can add that field to the lookup by piping the results to an outputlookup command. Try something along the lines of

| inputlookup yourlookup
| eval url="https://www.domain.com/go/".id
| table id, title, url
| outputlookup yourlookup

Re: How to transform a field into a new field using the old field as part of a string in the new field

user93 — Wed, 30 Sep 2020 03:40:37 GMT

Hey again @acfecondo75 !

So, that didn't quite work for me because my field has a space in it. I want to use the value of the id field where the filed name is "page id"

I have

|inputlookup table.csv
|search field=value

|eval created_epoch=strptime(Created,"%m/%d/%Y %H:%M")
|eval time_diff=now()-created_epoch

|eval url="https://www.domain.com/go/"."Page Id"

|table "Page Id",title,url,created_epoch,time_diff

|search time_diff<=2592000

My results show https://www.domain.com/go/Page Id. I want the value of the page id, so like https://www.domain.com/go/abcd1234

Re: How to transform a field into a new field using the old field as part of a string in the new field

acfecondo75 — Thu, 16 Jan 2020 20:37:16 GMT

if you need to reference a field with a space in it inside an eval statement, wrap the field name in single quotes to indicate that it's a field.

Re: How to transform a field into a new field using the old field as part of a string in the new field

acfecondo75 — Thu, 16 Jan 2020 20:38:02 GMT

you could also wrap it in $s. 'Page Id' or $Page Id$ will work.

Re: How to transform a field into a new field using the old field as part of a string in the new field

user93 — Thu, 16 Jan 2020 20:44:12 GMT

Brilliant! I chose the money sign 🙂

Thanks again