Combining 2 fields together

[#1]

Hi,

I have 2 columns within the same table -

Posting Month

Posting Year

Some how i want to show them together, any way of doing this?

Thanks

[alexandros17 · Accepted solution]

Load

...

Posting Month

Posting Year

...

Posting Year & Posting Month as newPosting

...

from

...

[sibideepak]

LOAD

.....

//Posting Month

//Posting Year

....

Posting Month & '-' & Posting Year as PostingYear

.................

[#4]

thank you! Perfect

[noman212]

you can concatenate them:

[Posting Year] & [Posting Month] AS newPosting.