# Issue with the "Flatten Variant" component: Invalid argument types for function 'GET': (VARCHAR(2000), VARCHAR(8))

**URL:** <https://matillioncommunity.discourse.group/t/issue-with-the-flatten-variant-component-invalid-argument-types-for-function-get-varchar-2000-varchar-8/1523>\
**Category:** Matillion ETL\
**Created:** [October 20, 2021, 3:40pm UTC](https://matillioncommunity.discourse.group/t/issue-with-the-flatten-variant-component-invalid-argument-types-for-function-get-varchar-2000-varchar-8/1523 "2021-10-20T15:40:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nathan.lang1614377435484](https://avatars.discourse-cdn.com/v4/letter/n/cab0a1/32.png) [@nathan.lang1614377435484](https://matillioncommunity.discourse.group/u/nathan.lang1614377435484)\
**Post date:** [October 20, 2021, 3:40pm UTC](https://matillioncommunity.discourse.group/t/issue-with-the-flatten-variant-component-invalid-argument-types-for-function-get-varchar-2000-varchar-8/1523/1 "2021-10-20T15:40:41Z")

</div>

I have run into an issue with the "Flatten Variant" Transform component

Error in the logs:

_Invalid argument types for function 'GET': (VARCHAR(2000), VARCHAR(8))_.

&nbsp;

 ![0694G00000Gx10GQAR_0D54G00007zHgyJSAS](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/d8a75d0827cc39447c5fbf08bdb0cbda99d0b762.png)

&nbsp;

SQL Generated:

SELECT&nbsp;

“FLATTEN\_VARIANT\_INPUT”.“workerJson”:“workerID”::variant as “workerID”

FROM&nbsp;

“$T{STAGE\_WORKER\_20211014\_101000}” “FLATTEN\_VARIANT\_INPUT”

---

<div class="post-metadata">

**Author:** ![nathan.lang1614377435484](https://avatars.discourse-cdn.com/v4/letter/n/cab0a1/32.png) [@nathan.lang1614377435484](https://matillioncommunity.discourse.group/u/nathan.lang1614377435484)\
**Post date:** [October 22, 2021, 1:13pm UTC](https://matillioncommunity.discourse.group/t/issue-with-the-flatten-variant-component-invalid-argument-types-for-function-get-varchar-2000-varchar-8/1523/2 "2021-10-22T13:13:43Z")

</div>

The reason for this error was due to the column not being of type "Variant". The fix for this is to use a Calculator component in front of things and the PARSE\_JSON function to put things into Variant which can then be digested by the Flatten Variant component.

&nbsp;